Excel for the Web: Analyzing & Manipulating Data Entries

Excel for the Web: Analyzing & Manipulating Data Entries

• find items or jump to a specific location in a worksheet
• replace cell contents in a worksheet
• sort data in a worksheet
• use filter buttons to filter data in a worksheet
• perform basic calculations and configure calculation options
• access and discover the Function library
• use cell references to perform calculations
• use data across multiple worksheets to reference data for formulas
• group and ungroup data in a worksheet
• use data validation to insert drop-down menus

Excel for the Web includes a wide variety of options for locating, displaying, and analyzing data entries. To start working with the data in a worksheet, use the sorting and filtering options for choosing what is the data displayed. You can also use the grouping tools to create groups and subgroups within a worksheet.

In this course learn how to use the Find and Replace tools to quickly locate and change data values in a data range or worksheet. Another option to easily insert values in a cell is using dropdown menus.

The power of Excel for the Web is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM, CHOOSE, and INDEX to quickly get totals or reference data and values. Also discover how to insert cell references to use data across multiple worksheets.

Excel for the Web: Analyzing Data with Tables & Charts

Excel for the Web: Analyzing Data with Tables & Charts

• insert, edit and remove a chart
• add chart titles, labels, and axis
• format a chart
• customize chart axes
• insert and edit data and field setup in a PivotTable
• edit and configure a PivotTable
• use sort tools to show and hide data in a PivotTable
• use filter tools to show and hide data in a PivotTable
• visualize data in a PivotChart

Analyze and present your data in a visually attractive manner in Excel for the Web. Learn how to prepare your data to insert your charts. Discover also how to change the appearance of your charts by changing the chart type or formatting different elements as titles, legends, and axis.
Excel for the Web includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables. You can also sort and filter your data with labels, values, or even slicers.
Even if Excel for the Web does not have an option to insert PivotCharts, you will see how to insert one from the Recommended Charts options and the Ideas tool.

Excel for the Web: Discovering the Application

Excel for the Web: Discovering the Application

• sign in and sign out of the application
• navigate and discover the Excel home page
• open a workbook from various locations
• create a workbook from various locations
• use templates to create workbooks
• create, open, and delete workbooks in OneDrive
• discover editing tools in Excel for the Web
• customize the application and spreadsheet interface
• discover the Viewing and Editing modes tools
• compare the browser and desktop Excel versions

Excel for the Web is the spreadsheet online application in the Microsoft Office 365 suite.

Learn how to sign-in and sign-out from the platform, as well as creating and opening your workbooks located in OneDrive.

Explore the interface and some of its features, including the ribbon, status bar, and various view modes.

Excel for the Web: Formatting Data

Excel for the Web: Formatting Data

• apply data formats to a data range
• use font format options in a spreadsheet
• insert, customize, and delete borders
• apply font and background colors
• use conditional formatting to highlight data
• transfer format styles from a worksheet to another
• insert and delete columns or rows
• resize columns and rows in a spreadsheet
• convert a data range into a table and edits its contents
• change the appearance of a table with the formatting styles

Excel for the Web makes it easier to enhance the presentation of your worksheets.

Discover how you can customize your font options, align data, and use colors. If you are working with large amounts of data, it will be useful to know how to resize rows and columns, as well as set borders.

In this course you will also learn how to create table and customize them with the formatting style options to improve the presentation of your data.

Excel for the Web: Inserting & Editing data

Excel for the Web: Inserting & Editing data

• select cells, rows, columns, and tables
• insert, edit, and replace data
• create and duplicate data series
• delete columns, rows, and data
• align data and merge cells
• undo and redo actions within a spreadsheet
• copy & paste data and formulas
• move data within a worksheet and a worbook
• insert, edit, and delete images and shapes
• insert, edit, and delete links

Excel for the Web contains a number of features to aid in data insertion and manipulation.

Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.

To enhance your worksheets, also learn how to insert pictures, shapes, and hyperlinks.

Excel for the Web: Saving & Managing Documents

Excel for the Web: Saving & Managing Documents

• save and download a copy of your workbook
• recover and restore different versions of a workbook
• create, customize, and delete sheet views
• work with different workbooks simultaneously
• add, customize, and delete worksheets
• review and get statistics from a workbook
• create an accessible workbook
• configure printing options
• protect and unprotect a workbook

In Excel for the Web, it is easy to create and save new workbooks. Learn how to save and download a copy of your documents, as well as protect your Excel workbooks from unwanted edits or use.

In Excel for the Web worksheet can contain more than numbers and text, so learn how to search for spelling mistakes and accessibility issues. You will also see how te get statistics concerning the data in your workbook.

In this course you will also discover how to work with various workbooks at the same time, manage spreadsheets, and create sheet views.

Excel for the Web: Working in a Document with Other Users

Excel for the Web: Working in a Document with Other Users

• publish a workbook online
• send a workbook by email
• create and share links with other users
• share a workbook via other Office applications
• add and manage comments in a workbook
• collaborate with other users in real-time

Excel for the Web enables you to easily share your documents via email or upload them to OneDrive and SharePoint to collaborate with your team. This version of Excel also comes with a comments feature to communicate with others editors.